Matt Johnson

Matt Johnson

Matt Johnson Community Champion

Overview

Overview
Emailmatt.johnson@sevan.com
Roles
Member
Badges52

About Me

About Me
Area of ExpertiseSolutions Building, Best Practices, Control Center, Automations, all the apps.
About MeI implement Smartsheet solutions full time.
How I Use SmartsheetProject/Program Management with roll-up reporting
Linkedinhttps://www.linkedin.com/in/itsmattjohnson/

Analytics

406
1,158
5.4k
  • Re: If Formula help

    Hi @Kelly P. I just wanted to put this out there too. I copy and pasted your question into the AI create a formula feature just to see what it would do. The formula came out slightly different but wi…
    ·
  • Re: Filter function in Dashboard

    Hi @Monster Man Sure thing. So say your main tracker has a column for region (North Pole and South Pole) ⛄️ and you want a Dashboard for each that are the exact same. On your metric sheet, you have a…
    ·
  • Re: Project Plans still allowing work on holidays

    Hi @Pamela Wagner That's an interesting question and I learned something too while researching the answer. Basically, although setting up non-working days excludes those days in duration calculations…
    ·
  • Re: Over active automation

    Hi @Gloydius You can deactivate an automation without deleting it by using the 3 dots to the right of the automations. Maybe deactivate them all and turn them back on 1-by-1 to figure it out. Given t…
    ·
  • Re: Dropdown Menu Functionality

    Hi @Mike B Yes, that's called Form Logic in Smartsheet. Click on a field in the Form Builder and then click on the Logic button circled below. Explaining it all here would be a long read but it's pre…
    ·
Avatar

Badges

  • Community 10th Anniversary
  • Automagician
  • Control Center Lead Certified
  • Question of the Month: September 2024 Participant
  • Grid View
  • Question of the Month: August 2024 Participant
  • Question of the Month: July 2024 Participant
  • Question of the Month: June 2024 Participant
  • Fourth Anniversary
  • Question of the Month: March 2024 Participant
  • 2023 Project Management Certified
  • $1B in annualized recurring revenue
  • Question of the Month: January 2024 Participant
  • Question of the Month: December Participant
  • Operate at Peak Human Nominee
  • Operate at Peak Human Nominator
  • Question of the Month: November Participant
  • Template Showcase Participant
  • Brandfolder
  • Question of the Month: September Participant